RtDbCopy Component Ver. 1.00 Copyright 1995 Tomasz Stanczak Compuserve: 100735,3273 TBatchMove is a very powerful component, but it has several shortcomings. What it cannot handle: 1) if you don't define a problem table and an error occurs, the whole operation will be canceled 2) it cannot change field data types in most cases 3) it cannot influence field data, it's copied as it is RtDbCopy is a replacement component, which offers: 1) before and after copy event, to do housekeeping actions 2) on every record event, to gauge the whole process or implement function filter 3) on every field event, where you get the data being read and set data being written, so that you can feed three destination fields from one source field or do whatever is appropriate 4) on every error event, where you can ask the user to decide if he wants to continue or break 5) through Mappings definition it lets you change field data types and/or sizes To achieve the best possible performance low-level BDE calls have been used whenever I could. At the end it comes very close to TBatchMove speed-wise. Files Included: README.WRI this file RTREGDC.PAS unit to register RtDbCopy with Delphi RTDBCOPY.PAS RtDbCopy itself (DCU in the demo version and PAS in the registered one) RTDCEDIT.PAS/DFM Property Editor for Mappings property. RTCONTS.PAS Constants for this and/or my other components RT.PAS unit with general functions I need TES1*.* test projects TES2*.* LOGIN.* Login dialog for the above projects RTDBCOPY.HLP RtDbCopy help file RTDBCOPY.KWF RtDbCopy keyword file 16\*.* Files specific to Delphi 1.0 32\*.* Files specific to Delphi 2.0 Installation: Copy the RT*.DCR, RT*.DCU and RT*.RES files to the same directory, including files from appropriate subdirectory(16\ or 32\). Then follow the Delphi instuctions for installing components. Both HLP and KWF files should probably be copied into DELPHI\BIN, the KWF is the keyword file, which can be installed with HELPINST.EXE. Test projects: With TES1 project you can batCopy every table you will. After choosing source table its structure will be shown in a StringGrid, so that you can edit destination field names, types and sizes. Then the batCopy progress will be shown with TGauge using OnRecord event, and every string field in will be uppercased in OnField event. TES2 project lets you chose both source and destination table, copy mode, and then compare performance of both TBatchMove and TRtDbCopy. Known problems: There is one problem I'm aware of, but I don't have any solution to it. This component cannot create new tables with Foxpro/dBase through ODBC, with both Microsoft and Intersolv drivers. The error lies not in the component itself, but in the TTable's CreateTable method, because Borland's TBatchMove has the same problem. Registration License fees: RtDbCopy alone, license fee is $20 (30 DM) plus $2 (3 DM) s&h as a part of RtControls, licence fee $39 (60 DM) plus $2 (3 DM) s&h Only following payment methods will be accepted: Compuserve: GO SWREG ID# 7405 RtDbCopy alone ID# 7197 RtControls Checks: Only checks drawn on a US bank valued in US$ or drawn on a German bank and valued in DM will be accepted. Please let us time after sending check, we cannot send you our product before the money is transferred. For details see help file. Credit Card Orders: You can order with MC, Visa, Amex, or Discover from Public (software) Library by calling 800-2424-PsL or 713-524-6394 or by FAX to 713-524-6398 or by CIS Email to 71355,470. You can also mail credit card orders to PsL at P.O.Box 35705, Houston, TX 77235-5705. THE ABOVE NUMBERS ARE FOR CREDIT CARD ORDERS ONLY. THE AUTHOR OF THIS PROGRAM CANNOT BE REACHED AT THESE NUMBERS. Any questions about the status of the shipment of the order, refunds, registration options, product details, technical support, volume discounts, dealer pricing, site licenses, non-credit card orders, etc, must be directed to Tomasz Stanczak: CIS: 100735,3273 Internet: 100735.3273@compuserve.com WWW: http://ourworld.compuserve.com/homepages/tomasz To order please specify Item# 14429, RtControls Delphi VCL Pack, price $39, s&h $2 (e-mail), $4 (Europe), $6 (overseas) To insure that you get the latest version, PsL will notify us the day of your order and we will ship the product directly to you. Shipping: Currently only e-mail shipping is supported, so please always state your e- mail address!. In the future post shipping including printed documentation will be possible (no promise!). Registered users will receive component’s full source code. Contact the author for multi-user discounts and site licenses. Shipping only through Compuserve Mail.